A bitmap index created with a bitmap for each distinct key, rather than indexing each row separately. Bitmap indexes store the rowids associated with a key value as a bitmap. Each bit in the bitmap corresponds to a possible rowid.
Type
Choose between Non-unique, Unique, Bitmap, Domain and Cluster.
Table Schema
The schema that contains the index.
Table Name
The table name.
Fields
Use the Field(s) Name dropdown list to select the field name.
Bitmap Join Index
In addition to a bitmap index on a single table, you can create a bitmap join index, which is a bitmap index for the join of two or more tables. A bitmap join index is a space efficient way of reducing the volume of data that must be joined by performing restrictions in advance.
Fields
Use the Schema, Table and Fields(s) Name dropdown lists to select the schema, table and field name.Bitmap Join
Use the Left Schema, Left Table, Left Field, Right Schema, Right Table and Right Field dropdown lists to select joined schemas, tables and fields respectively.